{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 作业二"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>age</th>\n",
       "      <th>hight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>张三</td>\n",
       "      <td>22</td>\n",
       "      <td>178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>李四</td>\n",
       "      <td>20</td>\n",
       "      <td>169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>王五</td>\n",
       "      <td>18</td>\n",
       "      <td>192</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  name  age  hight\n",
       "0   张三   22    178\n",
       "1   李四   20    169\n",
       "2   王五   18    192"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_table('data/1.txt')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>age</th>\n",
       "      <th>hight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>张三</td>\n",
       "      <td>22</td>\n",
       "      <td>178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>李四</td>\n",
       "      <td>20</td>\n",
       "      <td>169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>王五</td>\n",
       "      <td>18</td>\n",
       "      <td>192</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  name  age  hight\n",
       "0   张三   22    178\n",
       "1   李四   20    169\n",
       "2   王五   18    192"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv('data/2.csv',header=None,names=['name','age','hight'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>age</th>\n",
       "      <th>hight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>张三</td>\n",
       "      <td>22</td>\n",
       "      <td>178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>李四</td>\n",
       "      <td>20</td>\n",
       "      <td>169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>王五</td>\n",
       "      <td>18</td>\n",
       "      <td>192</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  name  age  hight\n",
       "0   张三   22    178\n",
       "1   李四   20    169\n",
       "2   王五   18    192"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_excel('data/3.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[     学号  姓名  年龄        班级\n",
       " 0  1001  张三  22  python04\n",
       " 1  1002  李四  23  python05\n",
       " 2  1003  王五  18  python06]"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_html('data/4.html',header=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>title</th>\n",
       "      <th>abstract</th>\n",
       "      <th>content</th>\n",
       "      <th>uid</th>\n",
       "      <th>pcount</th>\n",
       "      <th>flag</th>\n",
       "      <th>cdate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>python learn</td>\n",
       "      <td>python base</td>\n",
       "      <td>python is good</td>\n",
       "      <td>1</td>\n",
       "      <td>500</td>\n",
       "      <td>1</td>\n",
       "      <td>2018-10-10 16:10:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>java learn</td>\n",
       "      <td>java base</td>\n",
       "      <td>java is good</td>\n",
       "      <td>2</td>\n",
       "      <td>100</td>\n",
       "      <td>1</td>\n",
       "      <td>2018-10-11 16:32:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>c learn</td>\n",
       "      <td>c base</td>\n",
       "      <td>c is good</td>\n",
       "      <td>3</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>2018-10-11 20:17:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>c++ learn</td>\n",
       "      <td>c++ base</td>\n",
       "      <td>c++ is good</td>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>2018-10-11 22:56:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>php learn</td>\n",
       "      <td>php base</td>\n",
       "      <td>php is good</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>2018-10-12 09:09:23</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id         title     abstract         content  uid  pcount  flag  \\\n",
       "0   1  python learn  python base  python is good    1     500     1   \n",
       "1   2    java learn    java base    java is good    2     100     1   \n",
       "2   3       c learn       c base       c is good    3      35     1   \n",
       "3   4     c++ learn     c++ base     c++ is good    4      15     1   \n",
       "4   5     php learn     php base     php is good    5      13     1   \n",
       "\n",
       "                cdate  \n",
       "0 2018-10-10 16:10:35  \n",
       "1 2018-10-11 16:32:35  \n",
       "2 2018-10-11 20:17:39  \n",
       "3 2018-10-11 22:56:54  \n",
       "4 2018-10-12 09:09:23  "
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pymysql\n",
    "conn = pymysql.connect(host=\"localhost\", user=\"root\", password=\"\", db=\"blogdb\", charset=\"utf8\")\n",
    "sql = 'select * from blog limit 5'\n",
    "pd.read_sql(sql,conn)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>deal</th>\n",
       "      <th>image</th>\n",
       "      <th>location</th>\n",
       "      <th>price</th>\n",
       "      <th>shop</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5c3850127f3d5b4b2c43e03d</td>\n",
       "      <td>7374人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/img...</td>\n",
       "      <td>浙江 杭州</td>\n",
       "      <td>¥2338.00</td>\n",
       "      <td>卓辰数码旗舰店</td>\n",
       "      <td>[12期分期][两年保修]Apple/苹果 iPad 2018款 9.7英寸wifi新款平板...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5c38502a7f3d5b4b2c43e03e</td>\n",
       "      <td>7374人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>浙江 杭州</td>\n",
       "      <td>¥2338.00</td>\n",
       "      <td>卓辰数码旗舰店</td>\n",
       "      <td>[12期分期][两年保修]Apple/苹果 iPad 2018款 9.7英寸wifi新款平板...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5c38502a7f3d5b4b2c43e03f</td>\n",
       "      <td>None</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>上海</td>\n",
       "      <td>¥2565.00</td>\n",
       "      <td>applestore官方旗舰店</td>\n",
       "      <td>Apple/苹果 iPad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5c38502a7f3d5b4b2c43e040</td>\n",
       "      <td>907人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/img...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥4088.00</td>\n",
       "      <td>我乃寻梦人</td>\n",
       "      <td>2018新款Apple/苹果 11 英寸 iPad Pro 12.9英寸全面屏平板电脑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5c3850437f3d5b4b2c43e041</td>\n",
       "      <td>382人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>江苏 无锡</td>\n",
       "      <td>¥2298.00</td>\n",
       "      <td>岗隆数码专营店</td>\n",
       "      <td>12期分期/Apple/苹果 iPad 2018款 9.7英寸新款 air2升级版 32G/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5c3850437f3d5b4b2c43e042</td>\n",
       "      <td>12861人付款</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>江苏 南京</td>\n",
       "      <td>¥2565.00</td>\n",
       "      <td>苏宁易购官方旗舰店</td>\n",
       "      <td>【1月11日领券至高减430元】2018新款 Apple/苹果 9.7英寸iPad 智能平板...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5c3850437f3d5b4b2c43e043</td>\n",
       "      <td>79人付款</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>浙江 杭州</td>\n",
       "      <td>¥4668.00</td>\n",
       "      <td>卓辰数码旗舰店</td>\n",
       "      <td>Apple/苹果 iPad Pro 10.5英寸 平板电脑 64G/256G Wifi版 轻...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5c3850437f3d5b4b2c43e044</td>\n",
       "      <td>185人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>广东 东莞</td>\n",
       "      <td>¥1540.00</td>\n",
       "      <td>美足8689</td>\n",
       "      <td>Apple/苹果 iPad mini 4平板电脑7.9英寸迷你4 3网4G花呗分期免息</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5c3850437f3d5b4b2c43e045</td>\n",
       "      <td>2594人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥2058.00</td>\n",
       "      <td>深圳_恒波</td>\n",
       "      <td>Apple/苹果 iPad 2018款 苹果平板电脑9.7英寸ipad ipad2018新款</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5c3850437f3d5b4b2c43e046</td>\n",
       "      <td>609人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>江苏 南京</td>\n",
       "      <td>¥6499.00</td>\n",
       "      <td>苏宁易购官方旗舰店</td>\n",
       "      <td>【12期免息 0元加购天猫精灵】2018新款 Apple/苹果 iPad Pro 11英寸智...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5c3850437f3d5b4b2c43e047</td>\n",
       "      <td>None</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>上海</td>\n",
       "      <td>¥12499.00</td>\n",
       "      <td>applestore官方旗舰店</td>\n",
       "      <td>Apple/苹果 11 英寸 iPad Pro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5c3850437f3d5b4b2c43e048</td>\n",
       "      <td>67人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>浙江 金华</td>\n",
       "      <td>¥2048.00</td>\n",
       "      <td>浙江淳固电子商务有限公司</td>\n",
       "      <td>Apple/苹果iPad2018款平板电脑iPad Pro 9.7/10.5/12.9寸三网4G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5c3850437f3d5b4b2c43e049</td>\n",
       "      <td>68人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>广东 东莞</td>\n",
       "      <td>¥1228.00</td>\n",
       "      <td>美足8689</td>\n",
       "      <td>Apple/苹果ipad mini 3/2平板电脑7.9英寸wifi迷你3g花呗分期免息</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5c3850437f3d5b4b2c43e04a</td>\n",
       "      <td>23人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>江苏 南京</td>\n",
       "      <td>¥2308.00</td>\n",
       "      <td>apple天羽汇通专卖店</td>\n",
       "      <td>Apple/苹果 iPad 2018款 9.7英寸新款平板电脑wifi版</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5c3850437f3d5b4b2c43e04b</td>\n",
       "      <td>56人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥5598.00</td>\n",
       "      <td>领域数码通讯</td>\n",
       "      <td>Apple/苹果 11 英寸 iPad Pro 苹果平板 全面屏ipad 2018新款pro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5c3850437f3d5b4b2c43e04c</td>\n",
       "      <td>439人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥1750.00</td>\n",
       "      <td>akgbwh</td>\n",
       "      <td>Apple/苹果 iPad mini 4 7.9寸WiFi平板电脑3网4G迷你4 花呗分期</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>5c3850437f3d5b4b2c43e04d</td>\n",
       "      <td>186人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>江苏 扬州</td>\n",
       "      <td>¥2298.00</td>\n",
       "      <td>环球机库官方旗舰店</td>\n",
       "      <td>低至2278起/Apple/苹果 iPad 2018款 9.7英寸wifi新款平板 ipad...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>5c3850437f3d5b4b2c43e04e</td>\n",
       "      <td>494人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥1210.00</td>\n",
       "      <td>feidie品牌</td>\n",
       "      <td>Apple/苹果 iPad 2018款平板电脑9.7英寸ipad air2升级新款3网4G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>5c3850847f3d5b4b2c43e04f</td>\n",
       "      <td>1706人付款</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥2068.00</td>\n",
       "      <td>乐维网购</td>\n",
       "      <td>Apple/苹果 iPad 2018款 9.7英寸ipad苹果平板电脑 ipad2018新款</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5c3850847f3d5b4b2c43e050</td>\n",
       "      <td>919人付款</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥5558.00</td>\n",
       "      <td>xiaoshengjin</td>\n",
       "      <td>2018新款Apple/苹果 11 英寸 iPad Pro 11寸全面屏12.9寸平板电脑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5c3850847f3d5b4b2c43e051</td>\n",
       "      <td>907人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥4088.00</td>\n",
       "      <td>我乃寻梦人</td>\n",
       "      <td>2018新款Apple/苹果 11 英寸 iPad Pro 12.9英寸全面屏平板电脑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5c3850847f3d5b4b2c43e052</td>\n",
       "      <td>860人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>北京</td>\n",
       "      <td>¥5399.00</td>\n",
       "      <td>roamerhouse</td>\n",
       "      <td>2019全面屏2018新款Apple/苹果 iPad Pro 11寸国行12.9平板电脑4G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5c3850847f3d5b4b2c43e053</td>\n",
       "      <td>629人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>北京</td>\n",
       "      <td>¥5538.00</td>\n",
       "      <td>ygsd</td>\n",
       "      <td>当天发货 2018新款Apple/苹果 iPad Pro 11寸12.9全面屏平板三代</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5c3850847f3d5b4b2c43e054</td>\n",
       "      <td>1506人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>山东 济南</td>\n",
       "      <td>¥2288.00</td>\n",
       "      <td>三际数码官方旗舰店</td>\n",
       "      <td>天猫直送 2018款ipad Apple/苹果 iPad 2018款 9.7英寸32/128...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5c3850847f3d5b4b2c43e055</td>\n",
       "      <td>21人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>广东 东莞</td>\n",
       "      <td>¥2048.00</td>\n",
       "      <td>美足8689</td>\n",
       "      <td>Apple/苹果 iPad 2018款平板电脑9.7英寸3网4G 新款ipad2018 免息</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>5c3850847f3d5b4b2c43e056</td>\n",
       "      <td>88人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>上海</td>\n",
       "      <td>¥2998.00</td>\n",
       "      <td>二牛数码城</td>\n",
       "      <td>Apple/苹果 iPad Pro 10.5寸/11寸/12.9寸平板电脑 2018 iPa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>5c3850847f3d5b4b2c43e057</td>\n",
       "      <td>7人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>北京</td>\n",
       "      <td>¥6499.00</td>\n",
       "      <td>迈向数码旗舰店</td>\n",
       "      <td>[顺丰速发]2018款 Apple/苹果 11 英寸 iPad Pro 64GB/256GB...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>5c3850847f3d5b4b2c43e058</td>\n",
       "      <td>26人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>北京</td>\n",
       "      <td>¥4388.00</td>\n",
       "      <td>ygsd</td>\n",
       "      <td>现货速发Apple/苹果 iPad Pro 10.5寸 12.9寸 平板电脑 国行</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5c3850847f3d5b4b2c43e059</td>\n",
       "      <td>80人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>辽宁 沈阳</td>\n",
       "      <td>¥2188.00</td>\n",
       "      <td>hanyiguodu_</td>\n",
       "      <td>Apple/苹果 iPad 2018款美行美版9.7寸新款现货原封联保平板电脑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>5c3850847f3d5b4b2c43e05a</td>\n",
       "      <td>166人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥2058.00</td>\n",
       "      <td>旺隆数码</td>\n",
       "      <td>Apple/苹果 iPad 2018款 平板电脑9.7英寸 air2升级 新款ipad2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e0ff</td>\n",
       "      <td>7人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥5688.00</td>\n",
       "      <td>bvfdew</td>\n",
       "      <td>Apple/苹果 11 英寸 iPad Pro 2018 11/12.9寸 国行港行原封 老马</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e100</td>\n",
       "      <td>128人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥1019.00</td>\n",
       "      <td>包子浅唱小店</td>\n",
       "      <td>Apple/苹果 iPad mini2 迷你2正品3G平板电脑WiFi插卡7.9英寸全新</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e101</td>\n",
       "      <td>37人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥1898.00</td>\n",
       "      <td>四际数码digital</td>\n",
       "      <td>Apple/苹果 iPad mini 4 7.9寸平板电脑 3网4G 64 128GB 分期</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e102</td>\n",
       "      <td>37人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>上海</td>\n",
       "      <td>¥1850.00</td>\n",
       "      <td>祝哥哥123</td>\n",
       "      <td>Apple/苹果 iPad7/8 air3/4 9.7寸 平板电脑 wifi 2017/20...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e103</td>\n",
       "      <td>11人付款</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>上海</td>\n",
       "      <td>¥3340.00</td>\n",
       "      <td>winners11</td>\n",
       "      <td>Apple/苹果 iPad Pro 10.5寸平板电脑 ipad pro WiFi+4G国行...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e104</td>\n",
       "      <td>9人付款</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥5650.00</td>\n",
       "      <td>纯色心情1951</td>\n",
       "      <td>Apple/苹果 2018新款iPad pro11寸全面屏面容 pro12.9寸新款现货</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e105</td>\n",
       "      <td>9人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>上海</td>\n",
       "      <td>¥3010.00</td>\n",
       "      <td>亚菲数码</td>\n",
       "      <td>Apple/苹果 iPad Pro 10.5寸/11寸/12.9寸平板电脑 2018 iPa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e106</td>\n",
       "      <td>8人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>上海</td>\n",
       "      <td>¥2574.00</td>\n",
       "      <td>静房王树楷</td>\n",
       "      <td>Apple/苹果 iPad mini 4 WIFI 4G 32 64 128G 原封港版国行未激活</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e107</td>\n",
       "      <td>19人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥3840.00</td>\n",
       "      <td>一帆数码2013</td>\n",
       "      <td>Apple/苹果 iPad Pro12.9寸二代2018新款iPadpro10.5三代11寸美版</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e108</td>\n",
       "      <td>26人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>四川 成都</td>\n",
       "      <td>¥5238.00</td>\n",
       "      <td>cyipad7022</td>\n",
       "      <td>2018新款Apple/苹果 iPad Pro国行原封10.5寸11寸12寸苹果平板pro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e109</td>\n",
       "      <td>30人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥2276.01</td>\n",
       "      <td>宝诗丽1314</td>\n",
       "      <td>Apple/苹果 iPad pro11 4G版256G 美版日版新款10.5Pro平板电脑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e10a</td>\n",
       "      <td>45人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥1078.00</td>\n",
       "      <td>cyoyon11</td>\n",
       "      <td>Apple/苹果 iPad 2018款 iPad Air2升级新款mini4平板电脑9.7英寸</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e10b</td>\n",
       "      <td>57人付款</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>上海</td>\n",
       "      <td>¥2398.00</td>\n",
       "      <td>能良数码官方旗舰店</td>\n",
       "      <td>12期分期/送壳膜支架/现货速发Apple/苹果 iPad 2018款 9.7英寸wifi新...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e10c</td>\n",
       "      <td>12人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>江苏 南京</td>\n",
       "      <td>¥5900.00</td>\n",
       "      <td>小城往事如烟</td>\n",
       "      <td>新款Apple/苹果iPad Pro 11/12.9英寸全面屏64/256/521/1TB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e10d</td>\n",
       "      <td>24人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥2088.09</td>\n",
       "      <td>fongchingkit</td>\n",
       "      <td>Apple/苹果 2018新iPad9.7寸 新款平板电脑预定 原封正品香港代购</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e10e</td>\n",
       "      <td>35人付款</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>山东 济南</td>\n",
       "      <td>¥2168.00</td>\n",
       "      <td>三际数码官方旗舰店</td>\n",
       "      <td>12期分期2017款Apple/苹果 Ipad 9.7英寸wifi 平板电脑wlan 3/6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e10f</td>\n",
       "      <td>22人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>广东 广州</td>\n",
       "      <td>¥2999.00</td>\n",
       "      <td>波波逛街99</td>\n",
       "      <td>Apple/苹果2018款 ipad pro 12.9寸全面屏ipadpro10.5寸平板电脑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e110</td>\n",
       "      <td>23人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>江苏 南京</td>\n",
       "      <td>¥2565.00</td>\n",
       "      <td>裙子也疯狂</td>\n",
       "      <td>免息分期付款Apple/苹果 iPad 2018款 9.7英寸国行原封平板电脑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e111</td>\n",
       "      <td>16人付款</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>北京</td>\n",
       "      <td>¥3199.00</td>\n",
       "      <td>北京快捷购物</td>\n",
       "      <td>Apple/苹果 iPad pro 12.9寸/10.5/9.7平板电脑64G 256G 4...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e112</td>\n",
       "      <td>41人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥3840.00</td>\n",
       "      <td>一帆数码2013</td>\n",
       "      <td>Apple/苹果 iPad Pro 10.5寸12.9寸三代 2017 18二代11寸美版日版</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e113</td>\n",
       "      <td>56人付款</td>\n",
       "      <td>//g-search2.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥1550.00</td>\n",
       "      <td>飞翔鸟数码商城</td>\n",
       "      <td>Apple/苹果 iPad 2018款苹果平板电脑9.7英寸ipad air2升级版2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e114</td>\n",
       "      <td>13人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥7158.00</td>\n",
       "      <td>领域数码通讯</td>\n",
       "      <td>Apple/苹果 ipad pro 12.9寸 2018新款 iPad pro掌上平板电脑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e115</td>\n",
       "      <td>12人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥4600.00</td>\n",
       "      <td>sidfan32</td>\n",
       "      <td>港版iPad Pro 11 12.9英寸全面屏新款香港代购Apple/苹果Pro平板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e116</td>\n",
       "      <td>72人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥998.00</td>\n",
       "      <td>阳光数码通讯专卖</td>\n",
       "      <td>【三期免息】Apple/苹果 ipad mini2 32G平板电脑迷你2wifi16G32G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e117</td>\n",
       "      <td>29人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥1999.00</td>\n",
       "      <td>youjinglongye</td>\n",
       "      <td>2018年ipad air3新款Apple/苹果 iPad平板电脑9.7英寸 air2升级版</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e118</td>\n",
       "      <td>8人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i2/...</td>\n",
       "      <td>北京</td>\n",
       "      <td>¥5858.00</td>\n",
       "      <td>yatou81118</td>\n",
       "      <td>现货2019全面屏2018新款Apple/苹果 iPad Pro 11寸新12.9国行</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e119</td>\n",
       "      <td>61人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i3/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥1293.00</td>\n",
       "      <td>王的女人1984</td>\n",
       "      <td>Apple/苹果 iPad 2018款正品分期免息3网4G 6平板电脑2017款 air2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e11a</td>\n",
       "      <td>25人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥5638.00</td>\n",
       "      <td>隐河通讯</td>\n",
       "      <td>新品现货 2018款 Apple/苹果 iPad Pro 11英寸 11寸4G 12.9 WiFi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e11b</td>\n",
       "      <td>12人付款</td>\n",
       "      <td>//g-search1.alicdn.com/img/bao/uploaded/i4/i1/...</td>\n",
       "      <td>浙江 杭州</td>\n",
       "      <td>¥4470.00</td>\n",
       "      <td>zjdtpprint</td>\n",
       "      <td>Apple/苹果 iPad pro10.5 11 12.9寸原封未激活大陆行货全国联保</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>5c3850b17f3d5b4b2c43e11c</td>\n",
       "      <td>15人付款</td>\n",
       "      <td>//g-search3.alicdn.com/img/bao/uploaded/i4/i4/...</td>\n",
       "      <td>广东 深圳</td>\n",
       "      <td>¥2298.00</td>\n",
       "      <td>xiaoshengjin</td>\n",
       "      <td>原封 Apple/苹果 iPad mini 4 wifi美版 7.9寸迷你平板电脑 国行</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>224 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          _id      deal  \\\n",
       "0    5c3850127f3d5b4b2c43e03d   7374人付款   \n",
       "1    5c38502a7f3d5b4b2c43e03e   7374人付款   \n",
       "2    5c38502a7f3d5b4b2c43e03f      None   \n",
       "3    5c38502a7f3d5b4b2c43e040    907人付款   \n",
       "4    5c3850437f3d5b4b2c43e041    382人付款   \n",
       "5    5c3850437f3d5b4b2c43e042  12861人付款   \n",
       "6    5c3850437f3d5b4b2c43e043     79人付款   \n",
       "7    5c3850437f3d5b4b2c43e044    185人付款   \n",
       "8    5c3850437f3d5b4b2c43e045   2594人付款   \n",
       "9    5c3850437f3d5b4b2c43e046    609人付款   \n",
       "10   5c3850437f3d5b4b2c43e047      None   \n",
       "11   5c3850437f3d5b4b2c43e048     67人付款   \n",
       "12   5c3850437f3d5b4b2c43e049     68人付款   \n",
       "13   5c3850437f3d5b4b2c43e04a     23人付款   \n",
       "14   5c3850437f3d5b4b2c43e04b     56人付款   \n",
       "15   5c3850437f3d5b4b2c43e04c    439人付款   \n",
       "16   5c3850437f3d5b4b2c43e04d    186人付款   \n",
       "17   5c3850437f3d5b4b2c43e04e    494人付款   \n",
       "18   5c3850847f3d5b4b2c43e04f   1706人付款   \n",
       "19   5c3850847f3d5b4b2c43e050    919人付款   \n",
       "20   5c3850847f3d5b4b2c43e051    907人付款   \n",
       "21   5c3850847f3d5b4b2c43e052    860人付款   \n",
       "22   5c3850847f3d5b4b2c43e053    629人付款   \n",
       "23   5c3850847f3d5b4b2c43e054   1506人付款   \n",
       "24   5c3850847f3d5b4b2c43e055     21人付款   \n",
       "25   5c3850847f3d5b4b2c43e056     88人付款   \n",
       "26   5c3850847f3d5b4b2c43e057      7人付款   \n",
       "27   5c3850847f3d5b4b2c43e058     26人付款   \n",
       "28   5c3850847f3d5b4b2c43e059     80人付款   \n",
       "29   5c3850847f3d5b4b2c43e05a    166人付款   \n",
       "..                        ...       ...   \n",
       "194  5c3850b17f3d5b4b2c43e0ff      7人付款   \n",
       "195  5c3850b17f3d5b4b2c43e100    128人付款   \n",
       "196  5c3850b17f3d5b4b2c43e101     37人付款   \n",
       "197  5c3850b17f3d5b4b2c43e102     37人付款   \n",
       "198  5c3850b17f3d5b4b2c43e103     11人付款   \n",
       "199  5c3850b17f3d5b4b2c43e104      9人付款   \n",
       "200  5c3850b17f3d5b4b2c43e105      9人付款   \n",
       "201  5c3850b17f3d5b4b2c43e106      8人付款   \n",
       "202  5c3850b17f3d5b4b2c43e107     19人付款   \n",
       "203  5c3850b17f3d5b4b2c43e108     26人付款   \n",
       "204  5c3850b17f3d5b4b2c43e109     30人付款   \n",
       "205  5c3850b17f3d5b4b2c43e10a     45人付款   \n",
       "206  5c3850b17f3d5b4b2c43e10b     57人付款   \n",
       "207  5c3850b17f3d5b4b2c43e10c     12人付款   \n",
       "208  5c3850b17f3d5b4b2c43e10d     24人付款   \n",
       "209  5c3850b17f3d5b4b2c43e10e     35人付款   \n",
       "210  5c3850b17f3d5b4b2c43e10f     22人付款   \n",
       "211  5c3850b17f3d5b4b2c43e110     23人付款   \n",
       "212  5c3850b17f3d5b4b2c43e111     16人付款   \n",
       "213  5c3850b17f3d5b4b2c43e112     41人付款   \n",
       "214  5c3850b17f3d5b4b2c43e113     56人付款   \n",
       "215  5c3850b17f3d5b4b2c43e114     13人付款   \n",
       "216  5c3850b17f3d5b4b2c43e115     12人付款   \n",
       "217  5c3850b17f3d5b4b2c43e116     72人付款   \n",
       "218  5c3850b17f3d5b4b2c43e117     29人付款   \n",
       "219  5c3850b17f3d5b4b2c43e118      8人付款   \n",
       "220  5c3850b17f3d5b4b2c43e119     61人付款   \n",
       "221  5c3850b17f3d5b4b2c43e11a     25人付款   \n",
       "222  5c3850b17f3d5b4b2c43e11b     12人付款   \n",
       "223  5c3850b17f3d5b4b2c43e11c     15人付款   \n",
       "\n",
       "                                                 image location      price  \\\n",
       "0    //g-search1.alicdn.com/img/bao/uploaded/i4/img...    浙江 杭州   ¥2338.00   \n",
       "1    //g-search1.alicdn.com/img/bao/uploaded/i4/i3/...    浙江 杭州   ¥2338.00   \n",
       "2    //g-search2.alicdn.com/img/bao/uploaded/i4/i4/...       上海   ¥2565.00   \n",
       "3    //g-search1.alicdn.com/img/bao/uploaded/i4/img...    广东 深圳   ¥4088.00   \n",
       "4    //g-search3.alicdn.com/img/bao/uploaded/i4/i2/...    江苏 无锡   ¥2298.00   \n",
       "5    //g-search2.alicdn.com/img/bao/uploaded/i4/i4/...    江苏 南京   ¥2565.00   \n",
       "6    //g-search2.alicdn.com/img/bao/uploaded/i4/i4/...    浙江 杭州   ¥4668.00   \n",
       "7    //g-search1.alicdn.com/img/bao/uploaded/i4/i2/...    广东 东莞   ¥1540.00   \n",
       "8    //g-search1.alicdn.com/img/bao/uploaded/i4/i2/...    广东 深圳   ¥2058.00   \n",
       "9    //g-search3.alicdn.com/img/bao/uploaded/i4/i1/...    江苏 南京   ¥6499.00   \n",
       "10   //g-search3.alicdn.com/img/bao/uploaded/i4/i3/...       上海  ¥12499.00   \n",
       "11   //g-search3.alicdn.com/img/bao/uploaded/i4/i4/...    浙江 金华   ¥2048.00   \n",
       "12   //g-search1.alicdn.com/img/bao/uploaded/i4/i3/...    广东 东莞   ¥1228.00   \n",
       "13   //g-search3.alicdn.com/img/bao/uploaded/i4/i3/...    江苏 南京   ¥2308.00   \n",
       "14   //g-search3.alicdn.com/img/bao/uploaded/i4/i2/...    广东 深圳   ¥5598.00   \n",
       "15   //g-search1.alicdn.com/img/bao/uploaded/i4/i4/...    广东 深圳   ¥1750.00   \n",
       "16   //g-search1.alicdn.com/img/bao/uploaded/i4/i1/...    江苏 扬州   ¥2298.00   \n",
       "17   //g-search3.alicdn.com/img/bao/uploaded/i4/i3/...    广东 深圳   ¥1210.00   \n",
       "18   //g-search2.alicdn.com/img/bao/uploaded/i4/i1/...    广东 深圳   ¥2068.00   \n",
       "19   //g-search2.alicdn.com/img/bao/uploaded/i4/i3/...    广东 深圳   ¥5558.00   \n",
       "20   //g-search1.alicdn.com/img/bao/uploaded/i4/i1/...    广东 深圳   ¥4088.00   \n",
       "21   //g-search1.alicdn.com/img/bao/uploaded/i4/i2/...       北京   ¥5399.00   \n",
       "22   //g-search3.alicdn.com/img/bao/uploaded/i4/i1/...       北京   ¥5538.00   \n",
       "23   //g-search3.alicdn.com/img/bao/uploaded/i4/i4/...    山东 济南   ¥2288.00   \n",
       "24   //g-search1.alicdn.com/img/bao/uploaded/i4/i3/...    广东 东莞   ¥2048.00   \n",
       "25   //g-search1.alicdn.com/img/bao/uploaded/i4/i3/...       上海   ¥2998.00   \n",
       "26   //g-search3.alicdn.com/img/bao/uploaded/i4/i2/...       北京   ¥6499.00   \n",
       "27   //g-search3.alicdn.com/img/bao/uploaded/i4/i1/...       北京   ¥4388.00   \n",
       "28   //g-search1.alicdn.com/img/bao/uploaded/i4/i1/...    辽宁 沈阳   ¥2188.00   \n",
       "29   //g-search1.alicdn.com/img/bao/uploaded/i4/i3/...    广东 深圳   ¥2058.00   \n",
       "..                                                 ...      ...        ...   \n",
       "194  //g-search1.alicdn.com/img/bao/uploaded/i4/i2/...    广东 深圳   ¥5688.00   \n",
       "195  //g-search1.alicdn.com/img/bao/uploaded/i4/i4/...    广东 深圳   ¥1019.00   \n",
       "196  //g-search3.alicdn.com/img/bao/uploaded/i4/i4/...    广东 深圳   ¥1898.00   \n",
       "197  //g-search1.alicdn.com/img/bao/uploaded/i4/i2/...       上海   ¥1850.00   \n",
       "198  //g-search2.alicdn.com/img/bao/uploaded/i4/i3/...       上海   ¥3340.00   \n",
       "199  //g-search2.alicdn.com/img/bao/uploaded/i4/i2/...    广东 深圳   ¥5650.00   \n",
       "200  //g-search3.alicdn.com/img/bao/uploaded/i4/i2/...       上海   ¥3010.00   \n",
       "201  //g-search3.alicdn.com/img/bao/uploaded/i4/i4/...       上海   ¥2574.00   \n",
       "202  //g-search1.alicdn.com/img/bao/uploaded/i4/i3/...    广东 深圳   ¥3840.00   \n",
       "203  //g-search3.alicdn.com/img/bao/uploaded/i4/i2/...    四川 成都   ¥5238.00   \n",
       "204  //g-search3.alicdn.com/img/bao/uploaded/i4/i2/...    广东 深圳   ¥2276.01   \n",
       "205  //g-search1.alicdn.com/img/bao/uploaded/i4/i4/...    广东 深圳   ¥1078.00   \n",
       "206  //g-search2.alicdn.com/img/bao/uploaded/i4/i1/...       上海   ¥2398.00   \n",
       "207  //g-search3.alicdn.com/img/bao/uploaded/i4/i4/...    江苏 南京   ¥5900.00   \n",
       "208  //g-search1.alicdn.com/img/bao/uploaded/i4/i2/...    广东 深圳   ¥2088.09   \n",
       "209  //g-search2.alicdn.com/img/bao/uploaded/i4/i1/...    山东 济南   ¥2168.00   \n",
       "210  //g-search3.alicdn.com/img/bao/uploaded/i4/i4/...    广东 广州   ¥2999.00   \n",
       "211  //g-search3.alicdn.com/img/bao/uploaded/i4/i2/...    江苏 南京   ¥2565.00   \n",
       "212  //g-search2.alicdn.com/img/bao/uploaded/i4/i4/...       北京   ¥3199.00   \n",
       "213  //g-search3.alicdn.com/img/bao/uploaded/i4/i4/...    广东 深圳   ¥3840.00   \n",
       "214  //g-search2.alicdn.com/img/bao/uploaded/i4/i4/...    广东 深圳   ¥1550.00   \n",
       "215  //g-search1.alicdn.com/img/bao/uploaded/i4/i1/...    广东 深圳   ¥7158.00   \n",
       "216  //g-search3.alicdn.com/img/bao/uploaded/i4/i4/...    广东 深圳   ¥4600.00   \n",
       "217  //g-search1.alicdn.com/img/bao/uploaded/i4/i2/...    广东 深圳    ¥998.00   \n",
       "218  //g-search3.alicdn.com/img/bao/uploaded/i4/i4/...    广东 深圳   ¥1999.00   \n",
       "219  //g-search1.alicdn.com/img/bao/uploaded/i4/i2/...       北京   ¥5858.00   \n",
       "220  //g-search3.alicdn.com/img/bao/uploaded/i4/i3/...    广东 深圳   ¥1293.00   \n",
       "221  //g-search3.alicdn.com/img/bao/uploaded/i4/i1/...    广东 深圳   ¥5638.00   \n",
       "222  //g-search1.alicdn.com/img/bao/uploaded/i4/i1/...    浙江 杭州   ¥4470.00   \n",
       "223  //g-search3.alicdn.com/img/bao/uploaded/i4/i4/...    广东 深圳   ¥2298.00   \n",
       "\n",
       "                shop                                              title  \n",
       "0            卓辰数码旗舰店  [12期分期][两年保修]Apple/苹果 iPad 2018款 9.7英寸wifi新款平板...  \n",
       "1            卓辰数码旗舰店  [12期分期][两年保修]Apple/苹果 iPad 2018款 9.7英寸wifi新款平板...  \n",
       "2    applestore官方旗舰店                                      Apple/苹果 iPad  \n",
       "3              我乃寻梦人        2018新款Apple/苹果 11 英寸 iPad Pro 12.9英寸全面屏平板电脑  \n",
       "4            岗隆数码专营店  12期分期/Apple/苹果 iPad 2018款 9.7英寸新款 air2升级版 32G/...  \n",
       "5          苏宁易购官方旗舰店  【1月11日领券至高减430元】2018新款 Apple/苹果 9.7英寸iPad 智能平板...  \n",
       "6            卓辰数码旗舰店  Apple/苹果 iPad Pro 10.5英寸 平板电脑 64G/256G Wifi版 轻...  \n",
       "7             美足8689        Apple/苹果 iPad mini 4平板电脑7.9英寸迷你4 3网4G花呗分期免息  \n",
       "8              深圳_恒波     Apple/苹果 iPad 2018款 苹果平板电脑9.7英寸ipad ipad2018新款  \n",
       "9          苏宁易购官方旗舰店  【12期免息 0元加购天猫精灵】2018新款 Apple/苹果 iPad Pro 11英寸智...  \n",
       "10   applestore官方旗舰店                            Apple/苹果 11 英寸 iPad Pro  \n",
       "11      浙江淳固电子商务有限公司   Apple/苹果iPad2018款平板电脑iPad Pro 9.7/10.5/12.9寸三网4G  \n",
       "12            美足8689       Apple/苹果ipad mini 3/2平板电脑7.9英寸wifi迷你3g花呗分期免息  \n",
       "13      apple天羽汇通专卖店               Apple/苹果 iPad 2018款 9.7英寸新款平板电脑wifi版  \n",
       "14            领域数码通讯     Apple/苹果 11 英寸 iPad Pro 苹果平板 全面屏ipad 2018新款pro  \n",
       "15            akgbwh      Apple/苹果 iPad mini 4 7.9寸WiFi平板电脑3网4G迷你4 花呗分期  \n",
       "16         环球机库官方旗舰店  低至2278起/Apple/苹果 iPad 2018款 9.7英寸wifi新款平板 ipad...  \n",
       "17          feidie品牌      Apple/苹果 iPad 2018款平板电脑9.7英寸ipad air2升级新款3网4G  \n",
       "18              乐维网购     Apple/苹果 iPad 2018款 9.7英寸ipad苹果平板电脑 ipad2018新款  \n",
       "19      xiaoshengjin      2018新款Apple/苹果 11 英寸 iPad Pro 11寸全面屏12.9寸平板电脑  \n",
       "20             我乃寻梦人        2018新款Apple/苹果 11 英寸 iPad Pro 12.9英寸全面屏平板电脑  \n",
       "21       roamerhouse     2019全面屏2018新款Apple/苹果 iPad Pro 11寸国行12.9平板电脑4G  \n",
       "22              ygsd        当天发货 2018新款Apple/苹果 iPad Pro 11寸12.9全面屏平板三代  \n",
       "23         三际数码官方旗舰店  天猫直送 2018款ipad Apple/苹果 iPad 2018款 9.7英寸32/128...  \n",
       "24            美足8689     Apple/苹果 iPad 2018款平板电脑9.7英寸3网4G 新款ipad2018 免息  \n",
       "25             二牛数码城  Apple/苹果 iPad Pro 10.5寸/11寸/12.9寸平板电脑 2018 iPa...  \n",
       "26           迈向数码旗舰店  [顺丰速发]2018款 Apple/苹果 11 英寸 iPad Pro 64GB/256GB...  \n",
       "27              ygsd          现货速发Apple/苹果 iPad Pro 10.5寸 12.9寸 平板电脑 国行  \n",
       "28       hanyiguodu_            Apple/苹果 iPad 2018款美行美版9.7寸新款现货原封联保平板电脑  \n",
       "29              旺隆数码    Apple/苹果 iPad 2018款 平板电脑9.7英寸 air2升级 新款ipad2018  \n",
       "..               ...                                                ...  \n",
       "194           bvfdew    Apple/苹果 11 英寸 iPad Pro 2018 11/12.9寸 国行港行原封 老马  \n",
       "195           包子浅唱小店       Apple/苹果 iPad mini2 迷你2正品3G平板电脑WiFi插卡7.9英寸全新  \n",
       "196      四际数码digital     Apple/苹果 iPad mini 4 7.9寸平板电脑 3网4G 64 128GB 分期  \n",
       "197           祝哥哥123  Apple/苹果 iPad7/8 air3/4 9.7寸 平板电脑 wifi 2017/20...  \n",
       "198        winners11  Apple/苹果 iPad Pro 10.5寸平板电脑 ipad pro WiFi+4G国行...  \n",
       "199         纯色心情1951       Apple/苹果 2018新款iPad pro11寸全面屏面容 pro12.9寸新款现货  \n",
       "200             亚菲数码  Apple/苹果 iPad Pro 10.5寸/11寸/12.9寸平板电脑 2018 iPa...  \n",
       "201            静房王树楷  Apple/苹果 iPad mini 4 WIFI 4G 32 64 128G 原封港版国行未激活  \n",
       "202         一帆数码2013   Apple/苹果 iPad Pro12.9寸二代2018新款iPadpro10.5三代11寸美版  \n",
       "203       cyipad7022      2018新款Apple/苹果 iPad Pro国行原封10.5寸11寸12寸苹果平板pro  \n",
       "204          宝诗丽1314      Apple/苹果 iPad pro11 4G版256G 美版日版新款10.5Pro平板电脑  \n",
       "205         cyoyon11    Apple/苹果 iPad 2018款 iPad Air2升级新款mini4平板电脑9.7英寸  \n",
       "206        能良数码官方旗舰店  12期分期/送壳膜支架/现货速发Apple/苹果 iPad 2018款 9.7英寸wifi新...  \n",
       "207           小城往事如烟      新款Apple/苹果iPad Pro 11/12.9英寸全面屏64/256/521/1TB  \n",
       "208     fongchingkit           Apple/苹果 2018新iPad9.7寸 新款平板电脑预定 原封正品香港代购  \n",
       "209        三际数码官方旗舰店  12期分期2017款Apple/苹果 Ipad 9.7英寸wifi 平板电脑wlan 3/6...  \n",
       "210           波波逛街99    Apple/苹果2018款 ipad pro 12.9寸全面屏ipadpro10.5寸平板电脑  \n",
       "211            裙子也疯狂            免息分期付款Apple/苹果 iPad 2018款 9.7英寸国行原封平板电脑  \n",
       "212           北京快捷购物  Apple/苹果 iPad pro 12.9寸/10.5/9.7平板电脑64G 256G 4...  \n",
       "213         一帆数码2013    Apple/苹果 iPad Pro 10.5寸12.9寸三代 2017 18二代11寸美版日版  \n",
       "214          飞翔鸟数码商城     Apple/苹果 iPad 2018款苹果平板电脑9.7英寸ipad air2升级版2017  \n",
       "215           领域数码通讯      Apple/苹果 ipad pro 12.9寸 2018新款 iPad pro掌上平板电脑  \n",
       "216         sidfan32         港版iPad Pro 11 12.9英寸全面屏新款香港代购Apple/苹果Pro平板  \n",
       "217         阳光数码通讯专卖     【三期免息】Apple/苹果 ipad mini2 32G平板电脑迷你2wifi16G32G  \n",
       "218    youjinglongye     2018年ipad air3新款Apple/苹果 iPad平板电脑9.7英寸 air2升级版  \n",
       "219       yatou81118        现货2019全面屏2018新款Apple/苹果 iPad Pro 11寸新12.9国行  \n",
       "220         王的女人1984      Apple/苹果 iPad 2018款正品分期免息3网4G 6平板电脑2017款 air2  \n",
       "221             隐河通讯  新品现货 2018款 Apple/苹果 iPad Pro 11英寸 11寸4G 12.9 WiFi  \n",
       "222       zjdtpprint        Apple/苹果 iPad pro10.5 11 12.9寸原封未激活大陆行货全国联保  \n",
       "223     xiaoshengjin       原封 Apple/苹果 iPad mini 4 wifi美版 7.9寸迷你平板电脑 国行  \n",
       "\n",
       "[224 rows x 7 columns]"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pymongo\n",
    "client=pymongo.MongoClient(\"localhost\", 27017)\n",
    "db=client.taobao\n",
    "products = db.products\n",
    "pd.DataFrame(list(products.find()))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 作业三"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "X = np.array([[1.2, 1.5, 1.8],              [1.3, 1.4, 1.9],              [1.1, 1.6, 1.7]])\n",
    "y = np.array([5, 10, 9]).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[1.2, 1.5, 1.8],\n",
       "       [1.3, 1.4, 1.9],\n",
       "       [1.1, 1.6, 1.7]])"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3,)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "4 µs ± 28.2 ns per loop (mean ± std. dev. of 7 runs, 100000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit\n",
    "total=[]\n",
    "for p in X:\n",
    "    total.append(p[0]*y[0]+p[1]*y[1]+p[2]*y[2])\n",
    "# print(total)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "770 ns ± 1.82 ns per loop (mean ± std. dev. of 7 runs, 1000000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%timeit X.dot(y)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 作业四"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "np.random.seed(1) \n",
    "X = np.random.randint(1, 10, size=30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([6, 9, 6, 1, 1, 2, 8, 7, 3, 5, 6, 3, 5, 3, 5, 8, 8, 2, 8, 1, 7, 8,\n",
       "       7, 2, 1, 2, 9, 9, 4, 9])"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[6, 9, 6],\n",
       "       [1, 1, 2],\n",
       "       [8, 7, 3],\n",
       "       [5, 6, 3],\n",
       "       [5, 3, 5],\n",
       "       [8, 8, 2],\n",
       "       [8, 1, 7],\n",
       "       [8, 7, 2],\n",
       "       [1, 2, 9],\n",
       "       [9, 4, 9]])"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y = X.reshape(-1,3)\n",
    "y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[6, 9, 1],\n",
       "       [1, 1, 0],\n",
       "       [8, 7, 0],\n",
       "       [5, 6, 0],\n",
       "       [5, 3, 1],\n",
       "       [8, 8, 0],\n",
       "       [8, 1, 2],\n",
       "       [8, 7, 0],\n",
       "       [1, 2, 2],\n",
       "       [9, 4, 2]])"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y[y[:,2]<=3,2]=0\n",
    "y[(y[:,2]>3) & (y[:,2]<=6),2]=1\n",
    "y[y[:,2]>6,2]=2\n",
    "y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(array([[6, 9],\n",
       "        [1, 1],\n",
       "        [8, 7],\n",
       "        [5, 6],\n",
       "        [5, 3],\n",
       "        [8, 8],\n",
       "        [8, 1],\n",
       "        [8, 7],\n",
       "        [1, 2],\n",
       "        [9, 4]]), array([1, 0, 0, 0, 1, 0, 2, 0, 2, 2]))"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X_train,y_train=y[:,:2],y[:,2]\n",
    "X_train,y_train"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "分类为0的样本: \n",
      " [[1 1]\n",
      " [8 7]\n",
      " [5 6]\n",
      " [8 8]\n",
      " [8 7]]\n",
      "分类为1的样本: \n",
      " [[6 9]\n",
      " [5 3]]\n",
      "分类为2的样本: \n",
      " [[8 1]\n",
      " [1 2]\n",
      " [9 4]]\n"
     ]
    }
   ],
   "source": [
    "print('分类为0的样本:','\\n',X_train[y_train==0])\n",
    "print('分类为1的样本:','\\n',X_train[y_train==1])\n",
    "print('分类为2的样本:','\\n',X_train[y_train==2])"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
